[dbo].[amsp_CMGetPublishingServer]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@InServerCode	char	1
@InIPAddress	varchar(15)	15
@InPollRequestInd	char	1

Type	Action	Owning Principal
Grant	Execute	IMIS

SQL Script

-- =============================================
-- SP to get publishing server information based on the information provided.
--
-- Modifications
-- 06/20/2003    E.Tatsui    Created
-- =============================================
CREATE   PROCEDURE amsp_CMGetPublishingServer
    @InServerCode char(1),
    @InIPAddress varchar(15),
    @InPollRequestInd char(1)

AS

BEGIN

  SELECT *
    FROM Publish_Server_Ref
   WHERE PublishServerCode = @InServerCode
     AND ServerIPAddress = @InIPAddress
     AND PollRequestInd = @InPollRequestInd;

END

GO
GRANT EXECUTE ON  [dbo].[amsp_CMGetPublishingServer] TO [IMIS]
GO